Page 44 - Data_Science_Part_A C12

3.3.5 Spreadsheet and Sheet

A spreadsheet consists of sheets. Spreadsheet is the working area or page on the screen. A Spreadsheet consists of rows
and columns. (A Spreadsheet is like a book and sheet is like a page of a book). By default, a spreadsheet opens with one
sheet namely Sheet1. Users can change the name of the sheets and delete or add extra sheets if required. The name of
each sheet appears in the sheet tab towards the bottom of the spreadsheet. The active sheet i.e. the sheet being used,
is highlighted.

3.3.6 Rows

Rows are the set of rectangular boxes that are placed on top of each other in a horizontal position. They are numbered
20
from top to bottom along the left edge of the spreadsheet. There are 10,48,576 (2 ) rows in a spreadsheet of LibreOffice
Calc. The rows are numbered as 1,2,3,4,... .

3.3.7 Columns

Columns are the vertical set of rectangular boxes that are placed adjacent to each other in a vertical position. Columns
10
are labelled from left to right. There are 1024 (2 ) columns available in LibreOffice Calc.
3.3.8 Cells

A rectangular box formed by the intersection of a row and column is called a cell. Cell is the basic unit of a spreadsheet
where data (numbers, text, formulas, etc.) are entered.
3.3.9 Active Cell

The selected or activated cell is referred to as the active cell which is always highlighted with a thick border. The address
of the active cell is displayed in the name box for example, A1. In a spreadsheet, active cell is the place where data is
entered. Before entering any data in the cell, it has to be first selected by placing a cursor on it. Then, when we position
the mouse cursor on a cell, it gets selected and is ready to take data from the user or perform editing.

3.3.10 Cell Address

Each cell has a unique address which identifies its location. A cell address is identified with its column position followed
by its row number. For example, ‘A5’ is the cell address that is a combination of column ‘A’ and row ‘5’.
3.3.11 Sidebar

The sidebar in LibreOffice Calc provides quick access to various features, including Properties, Styles, Gallery, Navigator,
and Functions, allowing users to efficiently manage and format their spreadsheets.

3.3.12 Status Bar
It lies at the bottom of the screen. It shows the current status of an active application.

3.3.13 Sheet Tab

It lies below the active sheet of the screen. The names of the sheets appear in the sheet tabs at the bottom of the
spreadsheet. Click on the specific sheet tab to open it.
3.3.14 Horizontal Scroll Bar

It lies below the sheet tabs. It helps to view the spreadsheet screen by moving the scroll button from left to right and
vice-versa.
3.3.15 Vertical Scroll Bar

It lies towards the right side of the spreadsheet. It helps to view the spreadsheet by moving the scroll button from top
to bottom and vice-versa.

42 Touchpad Data Science-XII